'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object

'Usage
 
Dim instance As CalcLookupFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)

public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 2 - 3 items: lookup_value, lookup_vector, [result_vector].

Lookup_value is A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.

Lookup_vector A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.

Result_vector A range that contains only one row or column. It must be the same size as lookup_vector.

Return Value

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

CalcLookupFunction Class
CalcLookupFunction Members
Overload List